# Import, Export, and Publish Excel Data

Move delimited data into Excel, export workbook visuals and HTML, and choose the right publishing surface for downstream readers.

Excel often sits in the middle of a pipeline: CSV or application data arrives, a workbook adds formulas and presentation, and selected results are published as images, HTML, or another workbook.

## Import delimited text

Read CSV or other delimited input with `Import-OfficeCsv`, then pass its rows to `Export-OfficeExcel`. Specify the delimiter and culture rather than relying on machine defaults.

```powershell
Import-OfficeCsv -Path '.\Sales.csv' -Delimiter ';' -Culture en-US |
    Export-OfficeExcel -Path '.\Report.xlsx' -Sheet Sales -Append
```

The [delimited-import recipe](https://github.com/EvotecIT/OfficeIMO/blob/3b680b1b6fb15a268ff5525a4ca6cdd70b2f6613/PowerShell/PSWriteOffice/Examples/Excel/Recipe-Excel-ImportDelimited.ps1) imports an existing semicolon-delimited file into a named worksheet.

## Publish the useful part

Use `Export-OfficeDocumentImage` with `-Sheet` and `-Range` for a bounded report region, `-Sheet` and `-Chart` for a chart, or `-OutputDirectory` for worksheet images. Use `-OutputPath` only when the selection produces one image. HTML export is useful for review without Excel. `Export-OfficeExcel` turns PowerShell objects into a new or appended workbook when the pipeline begins with objects rather than an existing file.

Choose the smallest artifact that preserves the intended experience. A range image is good for a status message; an XLSX is better when recipients must filter, inspect formulas, or continue editing.

<!-- PowerForge markdown source sha256:F4F73B998651E50DFA014BC1F1F835B2C207CF0F21FE78466C75C93163677AA9; title=True -->

<!-- PowerForge markdown artifact sha256:DC2D91F723CE40EB24B670CF658D4CD1748148157ECFFE9BD36AE61AFF844632 -->
