# Excel Row 1 Issues **URL:** \ **Category:** Questions\ **Tags:** integration, export, calculation-options\ **Created:** [January 18, 2022, 9:15pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708 "2022-01-18T21:15:16Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 18, 2022, 9:15pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/1 "2022-01-18T21:15:16Z")
![Screen Shot 2022-01-18 at 3.10.10 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/6/6d8153f432e8a821173b607108f1b0ad090ee3e3.png) Uploading: Screen Shot 2022-01-18 at 3.10.22 PM.png... ![Screen Shot 2022-01-18 at 3.13.12 PM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/5/5a6b3487813a3c86cb46b421d367df4694fc766c.png) When exporting the the first row is showing "0" instead of Client Cost Price.... Any help? ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [January 18, 2022, 9:28pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/2 "2022-01-18T21:28:56Z")
Is the calculation outputting the calculation as Text or Number? ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 18, 2022, 9:43pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/3 "2022-01-18T21:43:53Z")
Number field in the table. when I use web viewer its saying table missing, because of row. The calculation works for other rows in excel, I cant figure out why not for this and a handful of others ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [January 18, 2022, 10:28pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/4 "2022-01-18T22:28:26Z")
"Table missing" is the default error. It's assuming that "row" is a field name but it can't see a field of that name in the current table, so it's prompting you to tell it which table the field is from. FileMaker translation of "row" is Get(RecordNumber). ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 19, 2022, 4:14pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/5 "2022-01-19T16:14:18Z")
Is it possible, all my relationships are correct, & it's just a weird "glitch" with Filemaker -\> Excel export? ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 19, 2022, 4:53pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/6 "2022-01-19T16:53:09Z")
I am also having issues with two column's I have: Description::TextMain Bio::TextMain The bio column exports the Description::TextMain for the 1st row but then continues with the correct data for the following rows ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 19, 2022, 5:35pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/7 "2022-01-19T17:35:42Z")
MALCOM ! I see what you meant... ![Screen Shot 2022-01-19 at 11.34.37 AM](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/7/745069cb95df6fb46027a1f6b17bdede01c06fbf.png) ---
**Author:** ![Kirk](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/kirk/32/2197_2.png) [@Kirk](https://the.fmsoup.org/u/Kirk)\ **Post date:** [January 19, 2022, 8:55pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/8 "2022-01-19T20:55:03Z")
Export a .mer (merge) file, rather than CSV or Excel. The first row a MERGE export is the field names in the export set. IDK if the number \> 14 digits, but Excel also cannot handle numeric fields with more than 14 digits. Found this out with credit card numbers; you have to break it into 2 fields for Excel to deal with it. ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [January 19, 2022, 9:21pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/9 "2022-01-19T21:21:44Z")
Excel reminds me of Harry > **[Harry, He's Here to Help](https://en.wikipedia.org/wiki/Harry,_He's_Here_to_Help)** > > Harry, He's Here to Help (French: Harry, un ami qui vous veut du bien - "Harry, a friend who wishes you well", US title: With a Friend Like Harry...) is a French film released in 2000. It was directed by Dominik Moll. > Middle-class couple Michel (Laurent Lucas) and Claire (Mathilde Seigner) are taking their three daughters, Jeanne, Sarah, and Iris, on a trip to see Michel's parents. The car has no air conditioning and the children are feeling sick, so the family decides to make a rest stop and tu... ---
**Author:** ![DrewFM](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@DrewFM](https://the.fmsoup.org/u/DrewFM)\ **Post date:** [January 19, 2022, 9:23pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/10 "2022-01-19T21:23:31Z")
😂 ahah ---
**Author:** ![Kirk](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/kirk/32/2197_2.png) [@Kirk](https://the.fmsoup.org/u/Kirk)\ **Post date:** [January 20, 2022, 6:21pm UTC](https://the.fmsoup.org/t/excel-row-1-issues/2708/11 "2022-01-20T18:21:07Z")
AFAIK, there is nothing Excel can do, that FileMaker can't do better, although there is more work to make a targeted solution than a generic "let-everyone-see-everything" Excel data set. It also violates a core principle of data management; there should only be "one-version-of-the-truth"; a single authoritative source of data. Or as the modern Confucius would state: "Man with one watch, always knows the time; man with 2 watches, never sure" 🙂