What data formats can inline AI handle?

inline AI supports .xlsx, .xlsm, .xltx, .xltm, .xls, .xlsb, .csv, .pdf, .docx, .pptx, .ppt, .png, .jpg, .jpeg, and web links. It reads and combines multiple formats in a single workflow.

Can it handle messy government or public datasets?

Yes. That is where inline AI shines. It normalizes inconsistent field names, codes, and date formats across files from different agencies or sources.

Does it replace statistical software like R or Python?

No. inline AI prepares your data for analysis. It handles cleanup and structuring so you can move directly into R, Python, or Excel-based analysis.

Is my research data safe?

Your files never leave your computer. inline AI runs locally, sends only minimal context to the AI model, and returns the result. No cloud storage, no data shared with third parties.

Research

Skip the data cleanup. Jump straight into analysis.

Get Download LinkDownload forWindows

10×Faster dataset merging

93%Less time on data cleanup

85%Less manual reformatting

The most frustrating part of research is losing hours to cleanup before you can even start thinking. inline AI takes care of that grunt work, so I can move straight into analysis.

Multi-File Merge

Combine multiple datasets into one workbook without repeating error-prone spreadsheet steps by hand.

AutoSaveOffMerged_County_Panel_2020_2024

FileHomeInsertDrawPage LayoutFormulasDataReviewViewAutomateHelpCommentsShare

L69⋮✕✓fx6037

4	FIPS	County	State	Year	Employment	Unemp Rate	Population	Med HH Income	Per Capita Inc	GDP ($M)
1	MERGED COUNTY ECONOMIC PANEL: 2020–2024
2	10 counties × 5 years \| Merged from BLS + Census + BEA \| Matched on FIPS code + year \| Prepared by Cicely AI
3	Source Files 3 Records In 150 Records Matched 50 Match Rate 100% Fields Joined 10 Merge Conflicts 0
5	6037	Los Angeles County	CA	2020	4,200	12.2%	10,014,009	$68,044	$62,350	710,000
6	6037	Los Angeles County	CA	2021	4,389	9.4%	9,993,981	$70,221	$64,345	736,980
7	6037	Los Angeles County	CA	2022	4,599	6.0%	10,003,995	$73,147	$67,026	777,450
8	6037	Los Angeles County	CA	2023	4,654	5.4%	10,034,037	$75,189	$68,897	800,880
9	6037	Los Angeles County	CA	2024	4,696	5.2%	10,064,079	$77,434	$70,954	825,020
10	17031	Cook County	IL	2020	2,480	11.4%	5,275,541	$62,088	$60,200	420,000
11	17031	Cook County	IL	2021	2,592	8.6%	5,264,990	$64,075	$62,126	435,960
12	17031	Cook County	IL	2022	2,716	5.2%	5,270,265	$66,745	$64,715	459,900
13	17031	Cook County	IL	2023	2,748	4.6%	5,286,092	$68,607	$66,521	473,760

◁▷Sheet1+

bls_employment_2020_2024.csv

census_population_2020_2024.csv

bea_income_2020_2024.csv

Merge these three county-level datasets into one panel. Match on FIPS code and year.

Public Data Cleaning

Normalize inconsistent sheets, codes, and field names from public data sources.

AutoSaveOffbls_raw_employment_extract

FileHomeInsertDrawPage LayoutFormulasDataReviewViewAutomateHelpCommentsShare

A14⋮✕✓fx06037

1	CLEANED BLS EMPLOYMENT DATA: 2024 ANNUAL
2	Normalized from BLS QCEW extract \| 20 counties \| Source: bls_raw_employment_extract.xlsx \| Prepared by Cicely AI
3	Rows Processed: 24 \| Issues Found: 37 \| Issues Fixed: 37 \| Data Quality: 100% \| Fields Normalized: 9 \| Footnotes Removed: 14
4	CLEANING LOG
5	Issue \| Count \| Example \| Action \| Status
6	Inconsistent state codes \| 6 found \| e.g. "Calif.", "calif", "CALIFORNIA" → CA \| Normalized to 2-letter USPS codes \| ✓ Fixed
7	Footnote markers in data \| 14 found \| e.g. "4,650(p)", "5.3%", "12,486†" \| Stripped all (p), , †, (r) markers \| ✓ Fixed
8	Blank / header rows \| 4 found \| e.g. Rows 1, 15, 22 (section breaks) \| Removed non-data rows \| ✓ Fixed
9	FIPS code format \| 5 found \| e.g. "6037" → "06037" (missing leading zero) \| Zero-padded to 5 digits \| ✓ Fixed
10	Inconsistent field names \| 5 found \| e.g. "unemp_rate" vs "Unemployment Rate %" \| Standardized to snake_case schema \| ✓ Fixed
11	Numeric stored as text \| 3 found \| e.g. "1,290,188" as string \| Converted to numeric values \| ✓ Fixed
12	CLEANED DATA
13	FIPS	County	State	Employment	Unemp Rate	Labor Force	Establishments	Avg Wkly Wage
14	06037	Los Angeles County	CA	4,694	5.2%	4,952	268,450	$1,485

◁▷Sheet1+

bls_raw_employment_extract.xlsx

This BLS dataset has inconsistent state codes, blank rows, and footnote markers. Clean it up.

Analysis-Ready Structuring

Reshape raw data into clean, structured inputs for downstream analysis and exploratory review in Excel.

AutoSaveOffRecovery_Analysis_2020_2024

FileHomeInsertDrawPage LayoutFormulasDataReviewViewAutomateHelpCommentsShare

M44⋮✕✓fx

1	DATA DICTIONARY: Structured County Panel
2	10 counties × 5 years (2020–2024) \| 50 observations \| 17 variables \| Prepared by Cicely AI
3	Field Name	Type	Description	Unit	Source
4	fips	text	5-digit FIPS county code (zero-padded)	-	Census Bureau
5	county	text	County name	-	Census Bureau
6	state	text	2-letter USPS state abbreviation	-	Census Bureau
7	year	integer	Calendar year (2020–2024)	-	All sources
8	employment_k	numeric	Total nonfarm employment, annual average	thousands	BLS QCEW
9	unemp_rate	numeric	Annual average unemployment rate	decimal (0.052 = 5.2%)	BLS LAUS
10	population	integer	Total resident population, mid-year estimate	persons	Census ACS
11	med_hh_income	numeric	Median household income, annual	USD nominal	Census ACS
12	per_capita_income	numeric	Per capita personal income, annual	USD nominal	BEA REIS
13	gdp_m	numeric	Gross domestic product, county level	millions USD	BEA GDP by County

◁▷Sheet1+

merged_county_panel_2020_2024.xlsx

Reshape this data so I can analyze recovery rates. Add YoY change and recovery index.

Presentation-Ready Formatting

Move from raw tables to clear charts and polished layouts ready for decks or reports.

AutoSaveOffrecovery_analysis_2020_2024

FileHomeInsertDrawPage LayoutFormulasDataReviewViewAutomateHelpCommentsShare

A10⋮✕✓fx1

8	#	County	State	Emp 2020 (K)	Emp 2024 (K)	Emp Growth	Unemp Δ (pp)	Income Grth	GDP Grth	Tier
1	U.S. COUNTY ECONOMIC RECOVERY REPORT
2	Post-Pandemic Performance Analysis \| 2020–2024 \| 10 Metropolitan Counties
3	Acme Policy Research \| March 2026 \| Prepared by Cicely AI
4	All 10 metropolitan counties recovered above 2020 employment baselines by 2024. Average employment growth was 13.7%, with Miami-Dade County (FL) leading at 18.4% and Los Angeles County (CA) trailing at 9.8%.
5	Sunbelt metros (Miami-Dade, Travis, Harris, Maricopa) posted the strongest gains (15–18%), while Midwest industrial counties (Cuyahoga, Cook) grew more modestly (10–12%).
6	Median household income grew 23.4% on average, with tech hubs (King County, WA) trailing at 17.5% and Los Angeles County (CA) leading at 26.3%.
7	Avg Employment Growth 13.7% Avg Income Growth 23.4% Best Recovery Miami-Dade County, FL Worst Recovery Los Angeles County, CA Avg Unemp Improvement -5.5%
9	COUNTY RECOVERY RANKING (sorted by cumulative employment growth, 2020–2024)
10	1	Miami-Dade County	FL	1,108	1,312	18.4%	-7.0 pp	26.2%	43.4%	Strong
11	2	Travis County	TX	642	756	17.8%	-2.4 pp	23.8%	49.1%	Strong
12	3	Harris County	TX	2,088	2,418	15.8%	-6.8 pp	21.9%	40.2%	Strong
13	4	Maricopa County	AZ	1,984	2,282	15.0%	-5.5 pp	26.0%	39.3%	Strong

◁▷Sheet1+

recovery_analysis_2020_2024.xlsx

Turn this analysis into a clean summary with charts for our policy brief.

FAQ

Frequently Asked Questions

Go from raw data to analysis-ready in minutes.

inline AI merges, cleans, and structures your datasets so you can skip straight to the thinking.

Get Download LinkDownload forWindows

1	MERGED COUNTY ECONOMIC PANEL: 2020–2024
2	10 counties × 5 years \| Merged from BLS + Census + BEA \| Matched on FIPS code + year \| Prepared by Cicely AI
3	Source Files 3 Records In 150 Records Matched 50 Match Rate 100% Fields Joined 10 Merge Conflicts 0
4	FIPS	County	State	Year	Employment	Unemp Rate	Population	Med HH Income	Per Capita Inc	GDP ($M)
5	6037	Los Angeles County	CA	2020	4,200	12.2%	10,014,009	$68,044	$62,350	710,000
6	6037	Los Angeles County	CA	2021	4,389	9.4%	9,993,981	$70,221	$64,345	736,980
7	6037	Los Angeles County	CA	2022	4,599	6.0%	10,003,995	$73,147	$67,026	777,450
8	6037	Los Angeles County	CA	2023	4,654	5.4%	10,034,037	$75,189	$68,897	800,880
9	6037	Los Angeles County	CA	2024	4,696	5.2%	10,064,079	$77,434	$70,954	825,020
10	17031	Cook County	IL	2020	2,480	11.4%	5,275,541	$62,088	$60,200	420,000
11	17031	Cook County	IL	2021	2,592	8.6%	5,264,990	$64,075	$62,126	435,960
12	17031	Cook County	IL	2022	2,716	5.2%	5,270,265	$66,745	$64,715	459,900
13	17031	Cook County	IL	2023	2,748	4.6%	5,286,092	$68,607	$66,521	473,760

MERGED COUNTY ECONOMIC PANEL: 2020–2024

10 counties × 5 years | Merged from BLS + Census + BEA | Matched on FIPS code + year | Prepared by Cicely AI

Source Files

Records In

150

Records Matched

Match Rate

100%

Fields Joined

Merge Conflicts

FIPS

County

State

Year

Employment

Unemp Rate

Population

Med HH Income

Per Capita Inc

GDP ($M)

6037

Los Angeles County

2020

4,200

12.2%

10,014,009

$68,044

$62,350

710,000

6037

Los Angeles County

2021

4,389

9.4%

9,993,981

$70,221

$64,345

736,980

6037

Los Angeles County

2022

4,599

6.0%

10,003,995

$73,147

$67,026

777,450

6037

Los Angeles County

2023

4,654

5.4%

10,034,037

$75,189

$68,897

800,880

6037

Los Angeles County

2024

4,696

5.2%

10,064,079

$77,434

$70,954

825,020

17031

Cook County

2020

2,480

11.4%

5,275,541

$62,088

$60,200

420,000

17031

Cook County

2021

2,592

8.6%

5,264,990

$64,075

$62,126

435,960

17031

Cook County

2022

2,716

5.2%

5,270,265

$66,745

$64,715

459,900

17031

Cook County

2023

2,748

4.6%

5,286,092

$68,607

$66,521

473,760

1	CLEANED BLS EMPLOYMENT DATA: 2024 ANNUAL
2	Normalized from BLS QCEW extract \| 20 counties \| Source: bls_raw_employment_extract.xlsx \| Prepared by Cicely AI
3	Rows Processed: 24 \| Issues Found: 37 \| Issues Fixed: 37 \| Data Quality: 100% \| Fields Normalized: 9 \| Footnotes Removed: 14
4	CLEANING LOG
5	Issue \| Count \| Example \| Action \| Status
6	Inconsistent state codes \| 6 found \| e.g. "Calif.", "calif", "CALIFORNIA" → CA \| Normalized to 2-letter USPS codes \| ✓ Fixed
7	Footnote markers in data \| 14 found \| e.g. "4,650(p)", "5.3%", "12,486†" \| Stripped all (p), , †, (r) markers \| ✓ Fixed
8	Blank / header rows \| 4 found \| e.g. Rows 1, 15, 22 (section breaks) \| Removed non-data rows \| ✓ Fixed
9	FIPS code format \| 5 found \| e.g. "6037" → "06037" (missing leading zero) \| Zero-padded to 5 digits \| ✓ Fixed
10	Inconsistent field names \| 5 found \| e.g. "unemp_rate" vs "Unemployment Rate %" \| Standardized to snake_case schema \| ✓ Fixed
11	Numeric stored as text \| 3 found \| e.g. "1,290,188" as string \| Converted to numeric values \| ✓ Fixed
12	CLEANED DATA
13	FIPS	County	State	Employment	Unemp Rate	Labor Force	Establishments	Avg Wkly Wage
14	06037	Los Angeles County	CA	4,694	5.2%	4,952	268,450	$1,485

CLEANED BLS EMPLOYMENT DATA: 2024 ANNUAL

Normalized from BLS QCEW extract | 20 counties | Source: bls_raw_employment_extract.xlsx | Prepared by Cicely AI

CLEANING LOG

Issue | Count | Example | Action | Status

Inconsistent state codes | 6 found | e.g. "Calif.", "calif", "CALIFORNIA" → CA | Normalized to 2-letter USPS codes | ✓ Fixed

Footnote markers in data | 14 found | e.g. "4,650(p)", "5.3%*", "12,486†" | Stripped all (p), *, †, (r) markers | ✓ Fixed

Blank / header rows | 4 found | e.g. Rows 1, 15, 22 (section breaks) | Removed non-data rows | ✓ Fixed

FIPS code format | 5 found | e.g. "6037" → "06037" (missing leading zero) | Zero-padded to 5 digits | ✓ Fixed

Inconsistent field names | 5 found | e.g. "unemp_rate" vs "Unemployment Rate %" | Standardized to snake_case schema | ✓ Fixed

Numeric stored as text | 3 found | e.g. "1,290,188" as string | Converted to numeric values | ✓ Fixed

CLEANED DATA

FIPS

County

State

Employment

Unemp Rate

Labor Force

Establishments

Avg Wkly Wage

06037

Los Angeles County

4,694

5.2%

4,952

268,450

$1,485

1	DATA DICTIONARY: Structured County Panel
2	10 counties × 5 years (2020–2024) \| 50 observations \| 17 variables \| Prepared by Cicely AI
3	Field Name	Type	Description	Unit	Source
4	fips	text	5-digit FIPS county code (zero-padded)	-	Census Bureau
5	county	text	County name	-	Census Bureau
6	state	text	2-letter USPS state abbreviation	-	Census Bureau
7	year	integer	Calendar year (2020–2024)	-	All sources
8	employment_k	numeric	Total nonfarm employment, annual average	thousands	BLS QCEW
9	unemp_rate	numeric	Annual average unemployment rate	decimal (0.052 = 5.2%)	BLS LAUS
10	population	integer	Total resident population, mid-year estimate	persons	Census ACS
11	med_hh_income	numeric	Median household income, annual	USD nominal	Census ACS
12	per_capita_income	numeric	Per capita personal income, annual	USD nominal	BEA REIS
13	gdp_m	numeric	Gross domestic product, county level	millions USD	BEA GDP by County

DATA DICTIONARY: Structured County Panel

10 counties × 5 years (2020–2024) | 50 observations | 17 variables | Prepared by Cicely AI

Field Name

Type

Description

Unit

Source

fips

text

5-digit FIPS county code (zero-padded)

Census Bureau

county

text

County name

Census Bureau

state

text

2-letter USPS state abbreviation

Census Bureau

year

integer

Calendar year (2020–2024)

All sources

employment_k

numeric

Total nonfarm employment, annual average

thousands

BLS QCEW

unemp_rate

numeric

Annual average unemployment rate

decimal (0.052 = 5.2%)

BLS LAUS

population

integer

Total resident population, mid-year estimate

persons

Census ACS

med_hh_income

numeric

Median household income, annual

USD nominal

Census ACS

per_capita_income

numeric

Per capita personal income, annual

USD nominal

BEA REIS

gdp_m

numeric

Gross domestic product, county level

millions USD

BEA GDP by County

1	U.S. COUNTY ECONOMIC RECOVERY REPORT
2	Post-Pandemic Performance Analysis \| 2020–2024 \| 10 Metropolitan Counties
3	Acme Policy Research \| March 2026 \| Prepared by Cicely AI
4	All 10 metropolitan counties recovered above 2020 employment baselines by 2024. Average employment growth was 13.7%, with Miami-Dade County (FL) leading at 18.4% and Los Angeles County (CA) trailing at 9.8%.
5	Sunbelt metros (Miami-Dade, Travis, Harris, Maricopa) posted the strongest gains (15–18%), while Midwest industrial counties (Cuyahoga, Cook) grew more modestly (10–12%).
6	Median household income grew 23.4% on average, with tech hubs (King County, WA) trailing at 17.5% and Los Angeles County (CA) leading at 26.3%.
7	Avg Employment Growth 13.7% Avg Income Growth 23.4% Best Recovery Miami-Dade County, FL Worst Recovery Los Angeles County, CA Avg Unemp Improvement -5.5%
8	#	County	State	Emp 2020 (K)	Emp 2024 (K)	Emp Growth	Unemp Δ (pp)	Income Grth	GDP Grth	Tier
9	COUNTY RECOVERY RANKING (sorted by cumulative employment growth, 2020–2024)
10	1	Miami-Dade County	FL	1,108	1,312	18.4%	-7.0 pp	26.2%	43.4%	Strong
11	2	Travis County	TX	642	756	17.8%	-2.4 pp	23.8%	49.1%	Strong
12	3	Harris County	TX	2,088	2,418	15.8%	-6.8 pp	21.9%	40.2%	Strong
13	4	Maricopa County	AZ	1,984	2,282	15.0%	-5.5 pp	26.0%	39.3%	Strong

U.S. COUNTY ECONOMIC RECOVERY REPORT

Post-Pandemic Performance Analysis | 2020–2024 | 10 Metropolitan Counties

Acme Policy Research | March 2026 | Prepared by Cicely AI

All 10 metropolitan counties recovered above 2020 employment baselines by 2024. Average employment growth was 13.7%, with Miami-Dade County (FL) leading at 18.4% and Los Angeles County (CA) trailing at 9.8%.

Sunbelt metros (Miami-Dade, Travis, Harris, Maricopa) posted the strongest gains (15–18%), while Midwest industrial counties (Cuyahoga, Cook) grew more modestly (10–12%).

Median household income grew 23.4% on average, with tech hubs (King County, WA) trailing at 17.5% and Los Angeles County (CA) leading at 26.3%.

Avg Employment Growth

13.7%

Avg Income Growth

23.4%

Best Recovery

Miami-Dade County, FL

Worst Recovery

Los Angeles County, CA

Avg Unemp Improvement

-5.5%

County

State

Emp 2020 (K)

Emp 2024 (K)

Emp Growth

Unemp Δ (pp)

Income Grth

GDP Grth

Tier

COUNTY RECOVERY RANKING (sorted by cumulative employment growth, 2020–2024)

Miami-Dade County

1,108

1,312

18.4%

-7.0 pp

26.2%

43.4%

Strong

Travis County

642

756

17.8%

-2.4 pp

23.8%

49.1%

Strong

Harris County

2,088

2,418

15.8%

-6.8 pp

21.9%

40.2%

Strong

Maricopa County

1,984

2,282

15.0%

-5.5 pp

26.0%

39.3%

Strong