Your AI assistant returns a tidy action list. You move it into a spreadsheet—and a comma in one task pushes the owner into the wrong column. A blank deadline is just as easy to miss: a neat-looking table can still carry an invented date.
This walkthrough turns five lines of fictional meeting notes into three traceable actions. You can copy the CSV below, compare the expected result, and download the workbook we created and checked for this guide.
Download the workbook and inspect the checks
Download the checked action-items workbook (.xlsx) — a small practice file with an Actions table and the fictional Source notes. It contains three actions; replace them before using the file for work.
Choose CSV or .xlsx before the handoff
The download contains two sheets: Actions and Source notes. Keep the .xlsx when a colleague needs both sheets and their formatting in one editable file. Export a separate CSV when the receiving system wants only the action rows. An Excel CSV export does not package every sheet into one file.
| Recipient needs | Handoff |
|---|---|
| Both sheets and date-cell formatting | Keep the .xlsx workbook. |
| Only Actions rows for another system | Export Actions separately as CSV; inspect the exported values. |
| Both needs at once | Supply two files and label their purposes. |
Documentation checked October 25, 2026: Microsoft’s file-format reference describes CSV as an active-sheet export. Its formatting and feature guide explains the differences between workbook and text formats. The choice above applies those rules to this practice file.
See the separate AI format-choice check
We made one separate request through Picsart using its Claude Sonnet 4.6 label (claude-sonnet-4-6). The model received the evidence brief and task below, without this article or an answer key. We wrote the brief after reading Microsoft’s pages; the model did not independently retrieve them. No Excel desktop test or file export was performed in this request.
Exact supplied prompt
Use only the evidence brief below to decide the handoff format. The evidence brief is an editor's paraphrase of Microsoft Support, not a verbatim quotation. EVIDENCE S1. Excel's CSV export writes the currently active worksheet, not all worksheets in a workbook. S2. CSV keeps displayed cell text and values, while workbook formatting and graphics are not retained. S3. The .xlsx workbook format retains worksheet/chart data and formatting. TASK Our practice workbook has an Actions sheet and a Source notes sheet, with formatted date cells. A colleague needs both sheets and their formatting in one editable Excel file. Another system separately asks for only the Actions rows as CSV. No macros are involved. Return under 100 words with three headings: Decision for the colleague Decision for the system Checks before handoff Give the evidence IDs supporting each decision. Keep the two deliverables distinct. Do not claim a CSV retains both sheets. Do not invent a GUI test or claim the files were opened in Excel. No web browsing or additional sources.
Original response, unchanged
## Decision for the colleague Send an **.xlsx file**. It preserves both the Actions sheet and the Source notes sheet, along with formatted date cells, in one editable file. *(S3)* ## Decision for the system Export the Actions sheet as **.csv**. Make that sheet active before exporting, as CSV captures only the active worksheet. Displayed cell values are retained; formatting is not. *(S1, S2)* ## Checks before handoff - Confirm the Actions sheet is active before the CSV export. *(S1)* - Confirm date cells display correctly as text in the CSV output. *(S2)* - Keep the two files separate; do not substitute one for the other.
Review: The two format decisions matched the supplied requirements and evidence. No factual correction was needed for those decisions. A whitespace count after removing Markdown markers and bullet-only tokens gives 100 words including headings and evidence IDs, so it did not meet the requested “under 100” limit under that count. Our short handoff note is: “Use the .xlsx for both sheets and formatting; provide a separate Actions-only CSV for the system.”
This checks how one response applied a supplied documentation brief. It does not test autonomous source retrieval, prove future reliability, or replace inspecting the actual deliverables.
Start with notes that expose the common mistakes
The example deliberately includes a comma, quotation marks, a missing deadline, an unapproved suggestion, and a review date. Those details reveal whether the output preserved the source. The people and project below are fictional; replace them with approved practice data before trying your own workflow.
L1: Aisha agreed to send the "Pilot, phase 2" agenda by 2026-10-28. L2: Ben agreed to update the signup form by 2026-10-29. L3: Cora agreed to confirm the room. No due date was provided. L4: Recording the session was suggested, but not approved. L5: The next review is 2026-10-30. This is not an action deadline.
If you first need to decide what belongs in an action list, use our meeting-notes guide. Here, the narrower job is preserving agreed actions during the move into a spreadsheet.
Give the assistant a fixed CSV contract
Ask for one row per agreed action and name the columns. A fixed shape makes the result easier to check than a table whose headings change each time. Keep the source-line reference even if you hide it later; it gives each row a place to check against.
Convert the notes below into CSV. Columns, in this exact order: Action,Owner,DueDate,SourceLine Rules: - Include only actions explicitly agreed in the notes. - Use only the owner and deadline stated for that action. - Leave a missing field empty; do not guess. - Use YYYY-MM-DD for explicit dates. - A review date is not an action deadline. - Keep a source-line reference for every row. - Enclose any field containing a comma or double quote in double quotes. - Escape a double quote inside a quoted field by doubling it. - Return only CSV, without a code fence or explanation. NOTES: L1: Aisha agreed to send the "Pilot, phase 2" agenda by 2026-10-28. L2: Ben agreed to update the signup form by 2026-10-29. L3: Cora agreed to confirm the room. No due date was provided. L4: Recording the session was suggested, but not approved. L5: The next review is 2026-10-30. This is not an action deadline.
For your own notes, avoid relative dates such as “next Thursday” unless the source provides a reference date and time zone. Resolve an ambiguous date with the person responsible before using it as a deadline.
Compare your output with the expected three rows
This is the CSV used to build the downloadable file. Your assistant may phrase a task differently, but it should preserve the same owners, dates and source references.
Action,Owner,DueDate,SourceLine "Send the ""Pilot, phase 2"" agenda",Aisha,2026-10-28,L1 Update the signup form,Ben,2026-10-29,L2 Confirm the room,Cora,,L3
In the first action, the outer quotes hold the comma inside one field. The doubled quotes represent the literal quotation marks around “Pilot, phase 2”. In Cora’s row, the two adjacent commas preserve an empty DueDate field. Do not replace that blank with the review date.
Expected exclusions: L4 contributes no row because recording was only suggested. L5 contributes no row because a review date is not an agreed task. If your output contains either, correct the extraction before importing it.
Import into Excel with the columns visible
Save the CSV text as a UTF-8 plain-text file named action-items.csv. Copy only the CSV, beginning with its header. In supported desktop Excel versions, use Data → From Text/CSV, choose the file, and inspect the preview. Set the delimiter to comma if needed.
Confirm that the preview has four columns before loading. Microsoft explains that opening a CSV directly uses default data-format settings, while the import route offers more control. See Microsoft’s text and CSV import instructions for version-specific options.
Check the DueDate column’s type rather than assuming that a date-looking string is a spreadsheet date. If a date imports as text, convert it explicitly and confirm the year, month and day. For identifiers with leading zeros in your own data, choose Text so those zeros are preserved. Save the checked result as .xlsx when you need workbook formatting and more than one sheet.
Fix the import before sharing
Everything lands in one column: return to the import preview, choose comma as the delimiter, and check that four columns appear before loading.
The quoted task splits into extra columns: compare the first CSV row with the example. Keep the outer quotation marks and the doubled quotes around the project name; do not remove them while copying.
The dates remain text: convert the DueDate column to dates explicitly, check the displayed year, month and day, and retain the empty cell for Cora. Formatting a cell alone does not prove that its stored value is a date.
Our checks found: three action rows and four columns; the comma and quotation marks remained inside the first action; Aisha and Ben retained their stated deadlines; Cora’s due date remained blank; and the two non-actions were excluded. The first two deadline cells were explicitly converted to date values and formatted as yyyy-mm-dd.
After export, we reopened the .xlsx file with our file tools and checked those cells again. We also inspected rendered previews of both sheets. These checks cover this sample and this conversion path. They do not establish how every Excel version, regional setting or future AI response will behave.
Use a short handoff check before sharing
Count: are there three action rows and four columns? Trace: can every row be traced to an agreed action? Inspect: does the first action still contain its comma and quotes? Confirm: is Cora’s due date blank, and are the other dates usable as dates?
For real data, inspect more than the first row. Include rows with punctuation, missing values, identifiers and ambiguous dates. A successful import proves the file can be read; it does not prove that the actions are factually correct. Check the source before assigning work.
Once the action list is checked, it can supply the next-actions section of a weekly update. Our weekly status report toolkit shows how to turn verified notes into a report without adding unsupported progress claims.
What was checked: the CSV was parsed, its cells compared with the source, and the resulting .xlsx file exported and reopened on October 25, 2026. This is a file-conversion example created with AI assistance. We did not open it in Excel desktop or benchmark a named AI product.